Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

DataServer configuration prerequisites

Before you configure a DataServer, you must:

Register your SQL Server database as an ODBC data source.

For details, see the "Registering your data source" section.

Determine which components you need on which platforms and then set up the appropriate executables on those platforms.

Table 5–1 lists the possible combinations and describes which executables you must set up on each machine. In this table, the term local indicates that the DataServer component runs on the same machine as the client, while the term remote indicates that the component runs on a different machine than the client.

Table 5–1: Installing the DataServer components 

Client	DataServer	Installing and configuring
Windows	Local Windows	Use the default OpenEdge client executable (prowin32.exe). The server component is embedded in the client executable.
Windows	Remote Windows	On the client machine, use the default OpenEdge client executable (prowin32.exe). On the host machine, to make a connection to the default DataServer executable (_msssrv.exe), use the default broker executable (_probrkr.exe) or configure a broker using the Progress Explorer.
UNIX	Remote Windows	On the client machine, use the default OpenEdge client executable (_progres). On the host machine, to make a connection to the default DataServer executable (_msssrv.exe), use the default broker executable (_probrkr.exe) or configure a broker using the Progress Explorer.

For instructions on setting up your DataServer configuration, see the sections that apply to the platforms that you will use. For example, if you are configuring a local DataServer, see the "Configuring a local DataServer" section. If you are building a remote DataServer configuration host, see the "Configuring a remote DataServer" section.